Airline Profiling Report

Dataset statistics

Number of variables	20
Number of observations	2793
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	522.8 KiB
Average record size in memory	191.7 B

Variable types

Categorical	9
Numeric	11

Alerts

`Route` has a high cardinality: 2793 distinct values	High cardinality
`ORIGIN` has a high cardinality: 262 distinct values	High cardinality
`DESTINATION` has a high cardinality: 267 distinct values	High cardinality
`ORIGIN_CITY_NAME` has a high cardinality: 256 distinct values	High cardinality
`DEST_CITY_NAME` has a high cardinality: 262 distinct values	High cardinality
`Origin_NAME` has a high cardinality: 262 distinct values	High cardinality
`Destination_NAME` has a high cardinality: 267 distinct values	High cardinality
`DEP_DELAY` is highly overall correlated with `ARR_DELAY` and 4 other fields	High correlation
`ARR_DELAY` is highly overall correlated with `DEP_DELAY` and 4 other fields	High correlation
`AIR_TIME` is highly overall correlated with `DEP_DELAY` and 4 other fields	High correlation
`Flight_Num` is highly overall correlated with `DEP_DELAY` and 4 other fields	High correlation
`DISTANCE` is highly overall correlated with `DEP_DELAY` and 4 other fields	High correlation
`Passenger_Num` is highly overall correlated with `DEP_DELAY` and 4 other fields	High correlation
`Route` is uniformly distributed	Uniform
`Route` has unique values	Unique

Reproduction

Analysis started	2023-09-22 19:02:28.270826
Analysis finished	2023-09-22 19:02:42.834634
Duration	14.56 seconds
Software version	pandas-profiling v3.6.6
Download configuration	config.json

Route
Categorical

HIGH CARDINALITY UNIFORM UNIQUE

Distinct	2793
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	43.6 KiB

ABE-ATL	1
ATL-EYW	1
GSO-IAD	1
GSP-IAD	1
HNL-IAD	1
Other values (2788)	2788

Length

Max length	7
Median length	7
Mean length	7
Min length	7

Characters and Unicode

Total characters	19551
Distinct characters	27
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2793 ?
Unique (%)	100.0%

Sample

1st row	ABE-ATL
2nd row	ABQ-ATL
3rd row	ABY-ATL
4th row	AEX-ATL
5th row	AGS-ATL

Common Values

Value	Count	Frequency (%)
ABE-ATL	1	< 0.1%
ATL-EYW	1	< 0.1%
GSO-IAD	1	< 0.1%
GSP-IAD	1	< 0.1%
HNL-IAD	1	< 0.1%
HSV-IAD	1	< 0.1%
IAD-LWB	1	< 0.1%
IAD-MDT	1	< 0.1%
ALB-EWR	1	< 0.1%
EWR-EYW	1	< 0.1%
Other values (2783)	2783	99.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
abe-atl	1	< 0.1%
abe-clt	1	< 0.1%
dtw-fll	1	< 0.1%
alb-clt	1	< 0.1%
aby-atl	1	< 0.1%
aex-atl	1	< 0.1%
ags-atl	1	< 0.1%
alb-atl	1	< 0.1%
ase-atl	1	< 0.1%
atl-csg	1	< 0.1%
Other values (2783)	2783	99.6%

Most occurring characters

Value	Count	Frequency (%)
-	2793	14.3%
A	1738	8.9%
S	1470	7.5%
L	1354	6.9%
D	1181	6.0%
C	884	4.5%
T	857	4.4%
M	851	4.4%
P	775	4.0%
O	766	3.9%
Other values (17)	6882	35.2%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	16758	85.7%
Dash Punctuation	2793	14.3%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	1738	10.4%
S	1470	8.8%
L	1354	8.1%
D	1181	7.0%
C	884	5.3%
T	857	5.1%
M	851	5.1%
P	775	4.6%
O	766	4.6%
I	719	4.3%
Other values (16)	6163	36.8%

Dash Punctuation

Value	Count	Frequency (%)
-	2793	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	16758	85.7%
Common	2793	14.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	1738	10.4%
S	1470	8.8%
L	1354	8.1%
D	1181	7.0%
C	884	5.3%
T	857	5.1%
M	851	5.1%
P	775	4.6%
O	766	4.6%
I	719	4.3%
Other values (16)	6163	36.8%

Common

Value	Count	Frequency (%)
-	2793	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	19551	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
-	2793	14.3%
A	1738	8.9%
S	1470	7.5%
L	1354	6.9%
D	1181	6.0%
C	884	4.5%
T	857	4.4%
M	851	4.4%
P	775	4.0%
O	766	3.9%
Other values (17)	6882	35.2%

ORIGIN
Categorical

Distinct	262
Distinct (%)	9.4%
Missing	0
Missing (%)	0.0%
Memory size	43.6 KiB

ATL	145
DFW	122
DEN	114
CLT	105
DTW	72
Other values (257)	2235

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	8379
Distinct characters	26
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	76 ?
Unique (%)	2.7%

Sample

1st row	ABE
2nd row	ABQ
3rd row	ABY
4th row	AEX
5th row	AGS

Common Values

Value	Count	Frequency (%)
ATL	145	5.2%
DFW	122	4.4%
DEN	114	4.1%
CLT	105	3.8%
DTW	72	2.6%
DCA	65	2.3%
EWR	61	2.2%
IAH	59	2.1%
LAS	58	2.1%
BOS	57	2.0%
Other values (252)	1935	69.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
atl	145	5.2%
dfw	122	4.4%
den	114	4.1%
clt	105	3.8%
dtw	72	2.6%
dca	65	2.3%
ewr	61	2.2%
iah	59	2.1%
las	58	2.1%
bos	57	2.0%
Other values (252)	1935	69.3%

Most occurring characters

Value	Count	Frequency (%)
A	1008	12.0%
L	797	9.5%
D	684	8.2%
C	519	6.2%
B	448	5.3%
S	433	5.2%
T	432	5.2%
I	377	4.5%
W	376	4.5%
E	368	4.4%
Other values (16)	2937	35.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	8379	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	1008	12.0%
L	797	9.5%
D	684	8.2%
C	519	6.2%
B	448	5.3%
S	433	5.2%
T	432	5.2%
I	377	4.5%
W	376	4.5%
E	368	4.4%
Other values (16)	2937	35.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	8379	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	1008	12.0%
L	797	9.5%
D	684	8.2%
C	519	6.2%
B	448	5.3%
S	433	5.2%
T	432	5.2%
I	377	4.5%
W	376	4.5%
E	368	4.4%
Other values (16)	2937	35.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	8379	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	1008	12.0%
L	797	9.5%
D	684	8.2%
C	519	6.2%
B	448	5.3%
S	433	5.2%
T	432	5.2%
I	377	4.5%
W	376	4.5%
E	368	4.4%
Other values (16)	2937	35.1%

DESTINATION
Categorical

Distinct	267
Distinct (%)	9.6%
Missing	0
Missing (%)	0.0%
Memory size	43.6 KiB

ORD	110
SLC	80
SEA	76
MSP	76
PHX	72
Other values (262)	2379

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	8379
Distinct characters	26
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	80 ?
Unique (%)	2.9%

Sample

1st row	ATL
2nd row	ATL
3rd row	ATL
4th row	ATL
5th row	ATL

Common Values

Value	Count	Frequency (%)
ORD	110	3.9%
SLC	80	2.9%
SEA	76	2.7%
MSP	76	2.7%
PHX	72	2.6%
SFO	71	2.5%
PHL	68	2.4%
TPA	62	2.2%
SFB	54	1.9%
STL	54	1.9%
Other values (257)	2070	74.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
ord	110	3.9%
slc	80	2.9%
sea	76	2.7%
msp	76	2.7%
phx	72	2.6%
sfo	71	2.5%
phl	68	2.4%
tpa	62	2.2%
las	54	1.9%
stl	54	1.9%
Other values (257)	2070	74.1%

Most occurring characters

Value	Count	Frequency (%)
S	1037	12.4%
A	730	8.7%
L	557	6.6%
P	555	6.6%
M	505	6.0%
D	497	5.9%
O	436	5.2%
T	425	5.1%
R	421	5.0%
F	369	4.4%
Other values (16)	2847	34.0%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	8379	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
S	1037	12.4%
A	730	8.7%
L	557	6.6%
P	555	6.6%
M	505	6.0%
D	497	5.9%
O	436	5.2%
T	425	5.1%
R	421	5.0%
F	369	4.4%
Other values (16)	2847	34.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	8379	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
S	1037	12.4%
A	730	8.7%
L	557	6.6%
P	555	6.6%
M	505	6.0%
D	497	5.9%
O	436	5.2%
T	425	5.1%
R	421	5.0%
F	369	4.4%
Other values (16)	2847	34.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	8379	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
S	1037	12.4%
A	730	8.7%
L	557	6.6%
P	555	6.6%
M	505	6.0%
D	497	5.9%
O	436	5.2%
T	425	5.1%
R	421	5.0%
F	369	4.4%
Other values (16)	2847	34.0%

ORIGIN_CITY_NAME
Categorical

Distinct	256
Distinct (%)	9.2%
Missing	0
Missing (%)	0.0%
Memory size	43.6 KiB

Atlanta, GA	145
Dallas/Fort Worth, TX	122
Denver, CO	114
Washington, DC	107
Charlotte, NC	105
Other values (251)	2200

Length

Max length	30
Median length	28
Mean length	13.088077
Min length	8

Characters and Unicode

Total characters	36555
Distinct characters	56
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	76 ?
Unique (%)	2.7%

Sample

1st row	Allentown/Bethlehem/Easton, PA
2nd row	Albuquerque, NM
3rd row	Albany, GA
4th row	Alexandria, LA
5th row	Augusta, GA

Common Values

Value	Count	Frequency (%)
Atlanta, GA	145	5.2%
Dallas/Fort Worth, TX	122	4.4%
Denver, CO	114	4.1%
Washington, DC	107	3.8%
Charlotte, NC	105	3.8%
Houston, TX	93	3.3%
Chicago, IL	79	2.8%
Detroit, MI	72	2.6%
New York, NY	67	2.4%
Phoenix, AZ	64	2.3%
Other values (246)	1825	65.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
tx	355	5.7%
fl	171	2.7%
ga	151	2.4%
co	150	2.4%
ca	147	2.3%
atlanta	145	2.3%
nc	140	2.2%
ny	133	2.1%
oh	127	2.0%
worth	122	1.9%
Other values (326)	4618	73.8%

Most occurring characters

Value	Count	Frequency (%)
	3466	9.5%
,	2793	7.6%
a	2619	7.2%
o	2052	5.6%
e	1897	5.2%
n	1875	5.1%
t	1846	5.0%
l	1787	4.9%
r	1469	4.0%
i	1423	3.9%
Other values (46)	15328	41.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	20746	56.8%
Uppercase Letter	9292	25.4%
Space Separator	3466	9.5%
Other Punctuation	3047	8.3%
Dash Punctuation	4	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	2619	12.6%
o	2052	9.9%
e	1897	9.1%
n	1875	9.0%
t	1846	8.9%
l	1787	8.6%
r	1469	7.1%
i	1423	6.9%
s	1313	6.3%
h	846	4.1%
Other values (16)	3619	17.4%

Uppercase Letter

Value	Count	Frequency (%)
C	1065	11.5%
A	1021	11.0%
N	818	8.8%
D	630	6.8%
L	534	5.7%
M	525	5.7%
T	511	5.5%
O	447	4.8%
I	415	4.5%
F	412	4.4%
Other values (15)	2914	31.4%

Other Punctuation

Value	Count	Frequency (%)
,	2793	91.7%
/	236	7.7%
.	18	0.6%

Space Separator

Value	Count	Frequency (%)
	3466	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	4	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	30038	82.2%
Common	6517	17.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	2619	8.7%
o	2052	6.8%
e	1897	6.3%
n	1875	6.2%
t	1846	6.1%
l	1787	5.9%
r	1469	4.9%
i	1423	4.7%
s	1313	4.4%
C	1065	3.5%
Other values (41)	12692	42.3%

Common

Value	Count	Frequency (%)
	3466	53.2%
,	2793	42.9%
/	236	3.6%
.	18	0.3%
-	4	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	36555	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	3466	9.5%
,	2793	7.6%
a	2619	7.2%
o	2052	5.6%
e	1897	5.2%
n	1875	5.1%
t	1846	5.0%
l	1787	4.9%
r	1469	4.0%
i	1423	3.9%
Other values (46)	15328	41.9%

DEST_CITY_NAME
Categorical

Distinct	262
Distinct (%)	9.4%
Missing	0
Missing (%)	0.0%
Memory size	43.6 KiB

Chicago, IL	142
Salt Lake City, UT	80
Minneapolis, MN	76
Seattle, WA	76
Phoenix, AZ	72
Other values (257)	2347

Length

Max length	34
Median length	28
Mean length	13.587898
Min length	8

Characters and Unicode

Total characters	37951
Distinct characters	57
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	79 ?
Unique (%)	2.8%

Sample

1st row	Atlanta, GA
2nd row	Atlanta, GA
3rd row	Atlanta, GA
4th row	Atlanta, GA
5th row	Atlanta, GA

Common Values

Value	Count	Frequency (%)
Chicago, IL	142	5.1%
Salt Lake City, UT	80	2.9%
Minneapolis, MN	76	2.7%
Seattle, WA	76	2.7%
Phoenix, AZ	72	2.6%
San Francisco, CA	71	2.5%
Philadelphia, PA	68	2.4%
Houston, TX	65	2.3%
New York, NY	63	2.3%
Tampa, FL	62	2.2%
Other values (252)	2018	72.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
fl	406	6.1%
ca	347	5.2%
san	191	2.9%
tx	187	2.8%
il	164	2.5%
chicago	142	2.1%
city	142	2.1%
ny	118	1.8%
pa	114	1.7%
az	98	1.5%
Other values (329)	4745	71.3%

Most occurring characters

Value	Count	Frequency (%)
	3861	10.2%
a	2903	7.6%
,	2793	7.4%
e	2102	5.5%
o	1977	5.2%
n	1844	4.9%
i	1697	4.5%
t	1527	4.0%
l	1456	3.8%
s	1291	3.4%
Other values (47)	16500	43.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	21305	56.1%
Uppercase Letter	9674	25.5%
Space Separator	3861	10.2%
Other Punctuation	3110	8.2%
Dash Punctuation	1	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	2903	13.6%
e	2102	9.9%
o	1977	9.3%
n	1844	8.7%
i	1697	8.0%
t	1527	7.2%
l	1456	6.8%
s	1291	6.1%
r	1288	6.0%
h	889	4.2%
Other values (16)	4331	20.3%

Uppercase Letter

Value	Count	Frequency (%)
A	973	10.1%
L	969	10.0%
C	926	9.6%
S	764	7.9%
N	661	6.8%
F	635	6.6%
M	574	5.9%
P	509	5.3%
T	455	4.7%
O	413	4.3%
Other values (16)	2795	28.9%

Other Punctuation

Value	Count	Frequency (%)
,	2793	89.8%
/	223	7.2%
.	94	3.0%

Space Separator

Value	Count	Frequency (%)
	3861	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	30979	81.6%
Common	6972	18.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	2903	9.4%
e	2102	6.8%
o	1977	6.4%
n	1844	6.0%
i	1697	5.5%
t	1527	4.9%
l	1456	4.7%
s	1291	4.2%
r	1288	4.2%
A	973	3.1%
Other values (42)	13921	44.9%

Common

Value	Count	Frequency (%)
	3861	55.4%
,	2793	40.1%
/	223	3.2%
.	94	1.3%
-	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	37951	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	3861	10.2%
a	2903	7.6%
,	2793	7.4%
e	2102	5.5%
o	1977	5.2%
n	1844	4.9%
i	1697	4.5%
t	1527	4.0%
l	1456	3.8%
s	1291	3.4%
Other values (47)	16500	43.5%

DEP_DELAY
Real number (ℝ)

Distinct	2526
Distinct (%)	90.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7754.2786

Minimum	0
Maximum	164175
Zeros	16
Zeros (%)	0.6%
Negative	0
Negative (%)	0.0%
Memory size	43.6 KiB

Quantile statistics

Minimum	0
5-th percentile	281
Q1	1862
median	4627
Q3	9810
95-th percentile	25982.8
Maximum	164175
Range	164175
Interquartile range (IQR)	7948

Descriptive statistics

Standard deviation	10249.228
Coefficient of variation (CV)	1.3217513
Kurtosis	41.326234
Mean	7754.2786
Median Absolute Deviation (MAD)	3415
Skewness	4.5564081
Sum	21657700
Variance	1.0504667 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	16	0.6%
3715	3	0.1%
3158	3	0.1%
60	3	0.1%
3340	3	0.1%
2475	3	0.1%
2377	3	0.1%
4476	3	0.1%
2509	3	0.1%
1581	3	0.1%
Other values (2516)	2750	98.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	16	0.6%
1	1	< 0.1%
2	1	< 0.1%
5	2	0.1%
6	1	< 0.1%
7	1	< 0.1%
10	1	< 0.1%
11	1	< 0.1%
12	1	< 0.1%
13	2	0.1%

Value	Count	Frequency (%)
164175	1	< 0.1%
149123	1	< 0.1%
97935	1	< 0.1%
89563	1	< 0.1%
79597	1	< 0.1%
75429	1	< 0.1%
68654	1	< 0.1%
63883	1	< 0.1%
62952	1	< 0.1%
62522	1	< 0.1%

ARR_DELAY
Real number (ℝ)

Distinct	2547
Distinct (%)	91.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	8387.2342

Minimum	0
Maximum	191244
Zeros	18
Zeros (%)	0.6%
Negative	0
Negative (%)	0.0%
Memory size	43.6 KiB

Quantile statistics

Minimum	0
5-th percentile	294
Q1	1888
median	5056
Q3	10406
95-th percentile	27829.4
Maximum	191244
Range	191244
Interquartile range (IQR)	8518

Descriptive statistics

Standard deviation	11497.404
Coefficient of variation (CV)	1.3708219
Kurtosis	50.543514
Mean	8387.2342
Median Absolute Deviation (MAD)	3657
Skewness	5.0417773
Sum	23425545
Variance	1.321903 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	18	0.6%
1473	4	0.1%
621	4	0.1%
1428	4	0.1%
1188	3	0.1%
6232	3	0.1%
933	3	0.1%
4928	3	0.1%
1694	3	0.1%
1978	3	0.1%
Other values (2537)	2745	98.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	18	0.6%
1	1	< 0.1%
2	2	0.1%
3	2	0.1%
4	1	< 0.1%
7	1	< 0.1%
9	1	< 0.1%
11	1	< 0.1%
15	2	0.1%
17	1	< 0.1%

Value	Count	Frequency (%)
191244	1	< 0.1%
181160	1	< 0.1%
108161	1	< 0.1%
105080	1	< 0.1%
88326	1	< 0.1%
85473	1	< 0.1%
75405	1	< 0.1%
71040	1	< 0.1%
69517	1	< 0.1%
69110	1	< 0.1%

AIR_TIME
Real number (ℝ)

Distinct	2765
Distinct (%)	99.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	70891.195

Minimum	2
Maximum	1987018
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	43.6 KiB

Quantile statistics

Minimum	2
5-th percentile	3898
Q1	18532
median	40993
Q3	83685
95-th percentile	246018.6
Maximum	1987018
Range	1987016
Interquartile range (IQR)	65153

Descriptive statistics

Standard deviation	98773.078
Coefficient of variation (CV)	1.3933053
Kurtosis	66.607213
Mean	70891.195
Median Absolute Deviation (MAD)	27744
Skewness	5.56066
Sum	1.9799911 × 10⁸
Variance	9.756121 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5670	2	0.1%
18258	2	0.1%
36607	2	0.1%
36968	2	0.1%
19350	2	0.1%
33774	2	0.1%
52475	2	0.1%
6634	2	0.1%
441	2	0.1%
43141	2	0.1%
Other values (2755)	2773	99.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2	1	< 0.1%
59	1	< 0.1%
69	1	< 0.1%
90	1	< 0.1%
91	1	< 0.1%
107	1	< 0.1%
166	1	< 0.1%
180	1	< 0.1%
200	1	< 0.1%
214	1	< 0.1%

Value	Count	Frequency (%)
1987018	1	< 0.1%
1213282	1	< 0.1%
847333	1	< 0.1%
823928	1	< 0.1%
787016	1	< 0.1%
763253	1	< 0.1%
755662	1	< 0.1%
752049	1	< 0.1%
748848	1	< 0.1%
669904	1	< 0.1%

Flight_Num
Real number (ℝ)

Distinct	1250
Distinct (%)	44.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	647.97888

Minimum	1
Maximum	8340
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	43.6 KiB

Quantile statistics

Minimum	1
5-th percentile	36
Q1	176
median	438
Q3	839
95-th percentile	2027
Maximum	8340
Range	8339
Interquartile range (IQR)	663

Descriptive statistics

Standard deviation	732.08773
Coefficient of variation (CV)	1.1298019
Kurtosis	14.09523
Mean	647.97888
Median Absolute Deviation (MAD)	285
Skewness	2.8901386
Sum	1809805
Variance	535952.45
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
180	42	1.5%
52	42	1.5%
50	33	1.2%
178	33	1.2%
176	24	0.9%
179	20	0.7%
174	19	0.7%
58	18	0.6%
177	16	0.6%
54	16	0.6%
Other values (1240)	2530	90.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	6	0.2%
2	12	0.4%
3	5	0.2%
4	10	0.4%
5	2	0.1%
6	3	0.1%
7	1	< 0.1%
8	12	0.4%
10	4	0.1%
12	2	0.1%

Value	Count	Frequency (%)
8340	1	< 0.1%
7156	1	< 0.1%
6511	1	< 0.1%
6320	1	< 0.1%
4999	1	< 0.1%
4820	1	< 0.1%
4794	1	< 0.1%
4774	1	< 0.1%
4707	1	< 0.1%
4594	1	< 0.1%

DISTANCE
Real number (ℝ)

Distinct	2761
Distinct (%)	98.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	498458.11

Minimum	237
Maximum	15642000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	43.6 KiB

Quantile statistics

Minimum	237
5-th percentile	24561.6
Q1	113142
median	264710
Q3	572136
95-th percentile	1811911.2
Maximum	15642000
Range	15641763
Interquartile range (IQR)	458994

Descriptive statistics

Standard deviation	754231.75
Coefficient of variation (CV)	1.5131296
Kurtosis	76.866637
Mean	498458.11
Median Absolute Deviation (MAD)	187338
Skewness	6.0680951
Sum	1.3921935 × 10⁹
Variance	5.6886553 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
77372	3	0.1%
108936	3	0.1%
110160	3	0.1%
26520	2	0.1%
81000	2	0.1%
60860	2	0.1%
815915	2	0.1%
77520	2	0.1%
313950	2	0.1%
499800	2	0.1%
Other values (2751)	2770	99.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
237	1	< 0.1%
390	1	< 0.1%
448	1	< 0.1%
612	1	< 0.1%
655	1	< 0.1%
1135	1	< 0.1%
1183	1	< 0.1%
1254	1	< 0.1%
1339	1	< 0.1%
1358	1	< 0.1%

Value	Count	Frequency (%)
15642000	1	< 0.1%
9622506	1	< 0.1%
6970212	1	< 0.1%
6481316	1	< 0.1%
6217560	1	< 0.1%
6100224	1	< 0.1%
6052298	1	< 0.1%
6009555	1	< 0.1%
5245348	1	< 0.1%
5187756	1	< 0.1%

Passenger_Num
Real number (ℝ)

Distinct	2725
Distinct (%)	97.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	84263.633

Minimum	84
Maximum	1082554
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	43.6 KiB

Quantile statistics

Minimum	84
5-th percentile	4542
Q1	22674
median	56800
Q3	109508
95-th percentile	264124.8
Maximum	1082554
Range	1082470
Interquartile range (IQR)	86834

Descriptive statistics

Standard deviation	95163.68
Coefficient of variation (CV)	1.1293565
Kurtosis	14.058747
Mean	84263.633
Median Absolute Deviation (MAD)	37108
Skewness	2.8874803
Sum	2.3534833 × 10⁸
Variance	9.0561259 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
23746	3	0.1%
7860	3	0.1%
83698	2	0.1%
84	2	0.1%
6458	2	0.1%
67942	2	0.1%
10202	2	0.1%
46736	2	0.1%
64842	2	0.1%
23220	2	0.1%
Other values (2715)	2771	99.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
84	2	0.1%
134	1	< 0.1%
142	1	< 0.1%
175.8281776	1	< 0.1%
187.6028402	1	< 0.1%
210	1	< 0.1%
214	1	< 0.1%
220	1	< 0.1%
224	1	< 0.1%
242	1	< 0.1%

Value	Count	Frequency (%)
1082554	1	< 0.1%
929026	1	< 0.1%
845678	1	< 0.1%
821694	1	< 0.1%
654284	1	< 0.1%
627434	1	< 0.1%
620950	1	< 0.1%
620644	1	< 0.1%
611424	1	< 0.1%
598240	1	< 0.1%

ITIN_FARE
Real number (ℝ)

Distinct	1426
Distinct (%)	51.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	391.4539

Minimum	0
Maximum	1999
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	43.6 KiB

Quantile statistics

Minimum	0
5-th percentile	166.9
Q1	312
median	384.5
Q3	468
95-th percentile	604.5
Maximum	1999
Range	1999
Interquartile range (IQR)	156

Descriptive statistics

Standard deviation	135.1319
Coefficient of variation (CV)	0.34520515
Kurtosis	10.069061
Mean	391.4539
Median Absolute Deviation (MAD)	77.25
Skewness	1.1836039
Sum	1093330.8
Variance	18260.631
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
370.5	8	0.3%
466	7	0.3%
309	7	0.3%
355.5	7	0.3%
464.5	7	0.3%
444	7	0.3%
344	7	0.3%
333	7	0.3%
408	7	0.3%
310.5	7	0.3%
Other values (1416)	2722	97.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	< 0.1%
11	2	0.1%
43.5	1	< 0.1%
54.75	1	< 0.1%
66.5	1	< 0.1%
71.5	1	< 0.1%
72	1	< 0.1%
72.5	1	< 0.1%
75	1	< 0.1%
79.5	1	< 0.1%

Value	Count	Frequency (%)
1999	1	< 0.1%
1465	1	< 0.1%
1307	1	< 0.1%
1172.5	1	< 0.1%
1069.5	1	< 0.1%
1055	1	< 0.1%
1017.5	1	< 0.1%
909	1	< 0.1%
902.75	1	< 0.1%
894.5	1	< 0.1%

Origin_TYPE
Categorical

Distinct	2
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	43.6 KiB

large_airport	2294
medium_airport	499

Length

Max length	14
Median length	13
Mean length	13.178661
Min length	13

Characters and Unicode

Total characters	36808
Distinct characters	13
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	medium_airport
2nd row	large_airport
3rd row	medium_airport
4th row	medium_airport
5th row	large_airport

Common Values

Value	Count	Frequency (%)
large_airport	2294	82.1%
medium_airport	499	17.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
large_airport	2294	82.1%
medium_airport	499	17.9%

Most occurring characters

Value	Count	Frequency (%)
r	7880	21.4%
a	5087	13.8%
i	3292	8.9%
e	2793	7.6%
_	2793	7.6%
p	2793	7.6%
o	2793	7.6%
t	2793	7.6%
l	2294	6.2%
g	2294	6.2%
Other values (3)	1996	5.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	34015	92.4%
Connector Punctuation	2793	7.6%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
r	7880	23.2%
a	5087	15.0%
i	3292	9.7%
e	2793	8.2%
p	2793	8.2%
o	2793	8.2%
t	2793	8.2%
l	2294	6.7%
g	2294	6.7%
m	998	2.9%
Other values (2)	998	2.9%

Connector Punctuation

Value	Count	Frequency (%)
_	2793	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	34015	92.4%
Common	2793	7.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
r	7880	23.2%
a	5087	15.0%
i	3292	9.7%
e	2793	8.2%
p	2793	8.2%
o	2793	8.2%
t	2793	8.2%
l	2294	6.7%
g	2294	6.7%
m	998	2.9%
Other values (2)	998	2.9%

Common

Value	Count	Frequency (%)
_	2793	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	36808	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
r	7880	21.4%
a	5087	13.8%
i	3292	8.9%
e	2793	7.6%
_	2793	7.6%
p	2793	7.6%
o	2793	7.6%
t	2793	7.6%
l	2294	6.2%
g	2294	6.2%
Other values (3)	1996	5.4%

Origin_NAME
Categorical

Distinct	262
Distinct (%)	9.4%
Missing	0
Missing (%)	0.0%
Memory size	43.6 KiB

Hartsfield Jackson Atlanta International Airport	145
Dallas Fort Worth International Airport	122
Denver International Airport	114
Charlotte Douglas International Airport	105
Detroit Metropolitan Wayne County Airport	72
Other values (257)	2235

Length

Max length	60
Median length	49
Mean length	36.049767
Min length	9

Characters and Unicode

Total characters	100687
Distinct characters	61
Distinct categories	8 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	76 ?
Unique (%)	2.7%

Sample

1st row	Lehigh Valley International Airport
2nd row	Albuquerque International Sunport
3rd row	Southwest Georgia Regional Airport
4th row	Alexandria International Airport
5th row	Augusta Regional At Bush Field

Common Values

Value	Count	Frequency (%)
Hartsfield Jackson Atlanta International Airport	145	5.2%
Dallas Fort Worth International Airport	122	4.4%
Denver International Airport	114	4.1%
Charlotte Douglas International Airport	105	3.8%
Detroit Metropolitan Wayne County Airport	72	2.6%
Ronald Reagan Washington National Airport	65	2.3%
Newark Liberty International Airport	61	2.2%
George Bush Intercontinental Houston Airport	59	2.1%
McCarran International Airport	58	2.1%
General Edward Lawrence Logan International Airport	57	2.0%
Other values (252)	1935	69.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
airport	2609	23.0%
international	1988	17.5%
fort	177	1.6%
field	170	1.5%
dallas	170	1.5%
jackson	152	1.3%
hartsfield	145	1.3%
atlanta	145	1.3%
worth	122	1.1%
regional	120	1.1%
Other values (434)	5542	48.9%

Most occurring characters

Value	Count	Frequency (%)
r	10228	10.2%
n	9815	9.7%
t	9721	9.7%
a	8986	8.9%
	8548	8.5%
o	8398	8.3%
i	7396	7.3%
e	6019	6.0%
l	5559	5.5%
A	3093	3.1%
Other values (51)	22924	22.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	79865	79.3%
Uppercase Letter	11805	11.7%
Space Separator	8548	8.5%
Other Punctuation	237	0.2%
Dash Punctuation	224	0.2%
Open Punctuation	3	< 0.1%
Close Punctuation	3	< 0.1%
Control	2	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
r	10228	12.8%
n	9815	12.3%
t	9721	12.2%
a	8986	11.3%
o	8398	10.5%
i	7396	9.3%
e	6019	7.5%
l	5559	7.0%
p	3009	3.8%
s	2017	2.5%
Other values (17)	8717	10.9%

Uppercase Letter

Value	Count	Frequency (%)
A	3093	26.2%
I	2186	18.5%
C	694	5.9%
D	597	5.1%
W	506	4.3%
F	484	4.1%
M	482	4.1%
H	458	3.9%
L	444	3.8%
B	406	3.4%
Other values (14)	2455	20.8%

Other Punctuation

Value	Count	Frequency (%)
/	156	65.8%
'	49	20.7%
.	27	11.4%
&	5	2.1%

Control

Value	Count	Frequency (%)
	1	50.0%
	1	50.0%

Space Separator

Value	Count	Frequency (%)
	8548	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	224	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	3	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	3	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	91670	91.0%
Common	9017	9.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
r	10228	11.2%
n	9815	10.7%
t	9721	10.6%
a	8986	9.8%
o	8398	9.2%
i	7396	8.1%
e	6019	6.6%
l	5559	6.1%
A	3093	3.4%
p	3009	3.3%
Other values (41)	19446	21.2%

Common

Value	Count	Frequency (%)
	8548	94.8%
-	224	2.5%
/	156	1.7%
'	49	0.5%
.	27	0.3%
&	5	0.1%
(	3	< 0.1%
)	3	< 0.1%
	1	< 0.1%
	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	100684	> 99.9%
None	3	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
r	10228	10.2%
n	9815	9.7%
t	9721	9.7%
a	8986	8.9%
	8548	8.5%
o	8398	8.3%
i	7396	7.3%
e	6019	6.0%
l	5559	5.5%
A	3093	3.1%
Other values (48)	22921	22.8%

None

Value	Count	Frequency (%)
â	1	33.3%
	1	33.3%
	1	33.3%

Origin_Longitude
Real number (ℝ)

Distinct	262
Distinct (%)	9.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-93.167509

Minimum	-176.646
Maximum	-68.828102
Zeros	0
Zeros (%)	0.0%
Negative	2793
Negative (%)	100.0%
Memory size	43.6 KiB

Quantile statistics

Minimum	-176.646
5-th percentile	-122.309
Q1	-104.673
median	-86.753502
Q3	-80.9431
95-th percentile	-73.7789
Maximum	-68.828102
Range	107.81789
Interquartile range (IQR)	23.729897

Descriptive statistics

Standard deviation	17.819703
Coefficient of variation (CV)	-0.1912652
Kurtosis	2.3379739
Mean	-93.167509
Median Absolute Deviation (MAD)	9.7158049
Skewness	-1.4076625
Sum	-260216.85
Variance	317.5418
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-84.428101	145	5.2%
-97.038002	122	4.4%
-104.6729965	114	4.1%
-80.94309998	105	3.8%
-83.35340118	72	2.6%
-77.037697	65	2.3%
-74.16870117	61	2.2%
-95.34140015	59	2.1%
-115.1520004	58	2.1%
-71.00520325	57	2.0%
Other values (252)	1935	69.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-176.6459961	1	< 0.1%
-162.598999	1	< 0.1%
-159.3390045	8	0.3%
-157.924228	23	0.8%
-156.951004	1	< 0.1%
-156.766008	2	0.1%
-156.429993	9	0.3%
-156.045603	11	0.4%
-155.0480042	2	0.1%
-152.4940033	1	< 0.1%

Value	Count	Frequency (%)
-68.82810211	6	0.2%
-70.309303	2	0.1%
-70.82330322	1	< 0.1%
-71.00520325	57	2.0%
-71.420403	2	0.1%
-71.435699	2	0.1%
-71.8757019	1	< 0.1%
-72.68319702	24	0.9%
-72.88680267	1	< 0.1%
-73.10019684	5	0.2%

Origin_Latitude
Real number (ℝ)

Distinct	262
Distinct (%)	9.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	37.258775

Minimum	19.721399
Maximum	71.285402
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	43.6 KiB

Quantile statistics

Minimum	19.721399
5-th percentile	26.41312
Q1	33.434299
median	38.805801
Q3	41.3032
95-th percentile	45.7775
Maximum	71.285402
Range	51.564003
Interquartile range (IQR)	7.8689005

Descriptive statistics

Standard deviation	6.1144027
Coefficient of variation (CV)	0.16410638
Kurtosis	2.2513547
Mean	37.258775
Median Absolute Deviation (MAD)	3.765602
Skewness	0.26340716
Sum	104063.76
Variance	37.38592
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
33.6367	145	5.2%
32.896801	122	4.4%
39.86169815	114	4.1%
35.2140007	105	3.8%
42.21239853	72	2.6%
38.8521	65	2.3%
40.69250107	61	2.2%
29.9843998	59	2.1%
36.08010101	58	2.1%
42.36429977	57	2.0%
Other values (252)	1935	69.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
19.72139931	2	0.1%
19.738783	11	0.4%
20.78560066	1	< 0.1%
20.8986	9	0.3%
21.32062	23	0.8%
21.97599983	8	0.3%
24.55610085	4	0.1%
25.79319954	25	0.9%
25.90679932	4	0.1%
26.072599	50	1.8%

Value	Count	Frequency (%)
71.285402	2	0.1%
66.88469696	1	< 0.1%
64.81510162	2	0.1%
61.17440033	17	0.6%
59.50329971	2	0.1%
58.35499954	4	0.1%
57.75	1	< 0.1%
56.80170059	1	< 0.1%
55.35559845	3	0.1%
51.87799835	1	< 0.1%

Destination_TYPE
Categorical

Distinct	2
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	43.6 KiB

large_airport	2371
medium_airport	422

Length

Max length	14
Median length	13
Mean length	13.151092
Min length	13

Characters and Unicode

Total characters	36731
Distinct characters	13
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	large_airport
2nd row	large_airport
3rd row	large_airport
4th row	large_airport
5th row	large_airport

Common Values

Value	Count	Frequency (%)
large_airport	2371	84.9%
medium_airport	422	15.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
large_airport	2371	84.9%
medium_airport	422	15.1%

Most occurring characters

Value	Count	Frequency (%)
r	7957	21.7%
a	5164	14.1%
i	3215	8.8%
e	2793	7.6%
_	2793	7.6%
p	2793	7.6%
o	2793	7.6%
t	2793	7.6%
l	2371	6.5%
g	2371	6.5%
Other values (3)	1688	4.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	33938	92.4%
Connector Punctuation	2793	7.6%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
r	7957	23.4%
a	5164	15.2%
i	3215	9.5%
e	2793	8.2%
p	2793	8.2%
o	2793	8.2%
t	2793	8.2%
l	2371	7.0%
g	2371	7.0%
m	844	2.5%
Other values (2)	844	2.5%

Connector Punctuation

Value	Count	Frequency (%)
_	2793	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	33938	92.4%
Common	2793	7.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
r	7957	23.4%
a	5164	15.2%
i	3215	9.5%
e	2793	8.2%
p	2793	8.2%
o	2793	8.2%
t	2793	8.2%
l	2371	7.0%
g	2371	7.0%
m	844	2.5%
Other values (2)	844	2.5%

Common

Value	Count	Frequency (%)
_	2793	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	36731	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
r	7957	21.7%
a	5164	14.1%
i	3215	8.8%
e	2793	7.6%
_	2793	7.6%
p	2793	7.6%
o	2793	7.6%
t	2793	7.6%
l	2371	6.5%
g	2371	6.5%
Other values (3)	1688	4.6%

Destination_NAME
Categorical

Distinct	267
Distinct (%)	9.6%
Missing	0
Missing (%)	0.0%
Memory size	43.6 KiB

Chicago O'Hare International Airport	110
Salt Lake City International Airport	80
Seattle Tacoma International Airport	76
Minneapolis-St Paul International/Wold-Chamberlain Airport	76
Phoenix Sky Harbor International Airport	72
Other values (262)	2379

Length

Max length	60
Median length	48
Mean length	34.883996
Min length	12

Characters and Unicode

Total characters	97431
Distinct characters	60
Distinct categories	8 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	80 ?
Unique (%)	2.9%

Sample

1st row	Hartsfield Jackson Atlanta International Airport
2nd row	Hartsfield Jackson Atlanta International Airport
3rd row	Hartsfield Jackson Atlanta International Airport
4th row	Hartsfield Jackson Atlanta International Airport
5th row	Hartsfield Jackson Atlanta International Airport

Common Values

Value	Count	Frequency (%)
Chicago O'Hare International Airport	110	3.9%
Salt Lake City International Airport	80	2.9%
Seattle Tacoma International Airport	76	2.7%
Minneapolis-St Paul International/Wold-Chamberlain Airport	76	2.7%
Phoenix Sky Harbor International Airport	72	2.6%
San Francisco International Airport	71	2.5%
Philadelphia International Airport	68	2.4%
Tampa International Airport	62	2.2%
Orlando Sanford International Airport	54	1.9%
St Louis Lambert International Airport	54	1.9%
Other values (257)	2070	74.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
airport	2679	24.0%
international	2075	18.6%
san	191	1.7%
regional	172	1.5%
chicago	145	1.3%
city	120	1.1%
o'hare	110	1.0%
field	107	1.0%
orlando	101	0.9%
st	93	0.8%
Other values (456)	5349	48.0%

Most occurring characters

Value	Count	Frequency (%)
r	10178	10.4%
n	9614	9.9%
t	9450	9.7%
a	8935	9.2%
	8350	8.6%
o	8158	8.4%
i	7495	7.7%
e	5655	5.8%
l	4861	5.0%
p	3167	3.3%
Other values (50)	21568	22.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	76882	78.9%
Uppercase Letter	11651	12.0%
Space Separator	8350	8.6%
Other Punctuation	304	0.3%
Dash Punctuation	216	0.2%
Control	14	< 0.1%
Close Punctuation	7	< 0.1%
Open Punctuation	7	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
r	10178	13.2%
n	9614	12.5%
t	9450	12.3%
a	8935	11.6%
o	8158	10.6%
i	7495	9.7%
e	5655	7.4%
l	4861	6.3%
p	3167	4.1%
s	1528	2.0%
Other values (16)	7841	10.2%

Uppercase Letter

Value	Count	Frequency (%)
A	2924	25.1%
I	2234	19.2%
S	937	8.0%
C	624	5.4%
M	520	4.5%
P	455	3.9%
L	430	3.7%
F	396	3.4%
H	383	3.3%
R	366	3.1%
Other values (14)	2382	20.4%

Other Punctuation

Value	Count	Frequency (%)
/	122	40.1%
'	110	36.2%
.	63	20.7%
&	9	3.0%

Control

Value	Count	Frequency (%)
	7	50.0%
	7	50.0%

Space Separator

Value	Count	Frequency (%)
	8350	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	216	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	7	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	7	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	88533	90.9%
Common	8898	9.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
r	10178	11.5%
n	9614	10.9%
t	9450	10.7%
a	8935	10.1%
o	8158	9.2%
i	7495	8.5%
e	5655	6.4%
l	4861	5.5%
p	3167	3.6%
A	2924	3.3%
Other values (40)	18096	20.4%

Common

Value	Count	Frequency (%)
	8350	93.8%
-	216	2.4%
/	122	1.4%
'	110	1.2%
.	63	0.7%
&	9	0.1%
)	7	0.1%
(	7	0.1%
	7	0.1%
	7	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	97410	> 99.9%
None	21	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
r	10178	10.4%
n	9614	9.9%
t	9450	9.7%
a	8935	9.2%
	8350	8.6%
o	8158	8.4%
i	7495	7.7%
e	5655	5.8%
l	4861	5.0%
p	3167	3.3%
Other values (47)	21547	22.1%

None

Value	Count	Frequency (%)
	7	33.3%
	7	33.3%
â	7	33.3%

Destination_Longitude
Real number (ℝ)

Distinct	267
Distinct (%)	9.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-95.67852

Minimum	-165.44501
Maximum	-70.309303
Zeros	0
Zeros (%)	0.0%
Negative	2793
Negative (%)	100.0%
Memory size	43.6 KiB

Quantile statistics

Minimum	-165.44501
5-th percentile	-122.375
Q1	-111.983
median	-90.258003
Q3	-81.308998
95-th percentile	-74.168701
Maximum	-70.309303
Range	95.135704
Interquartile range (IQR)	30.674004

Descriptive statistics

Standard deviation	17.789109
Coefficient of variation (CV)	-0.18592583
Kurtosis	0.22314025
Mean	-95.67852
Median Absolute Deviation (MAD)	10.105301
Skewness	-0.84544363
Sum	-267230.11
Variance	316.45239
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-87.9048	110	3.9%
-111.9779968	80	2.9%
-122.308998	76	2.7%
-93.221802	76	2.7%
-112.012001	72	2.6%
-122.375	71	2.5%
-75.2410965	68	2.4%
-82.53320312	62	2.2%
-81.23750305	54	1.9%
-90.370003	54	1.9%
Other values (257)	2070	74.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-165.4450073	2	0.1%
-162.598999	1	< 0.1%
-161.8379974	1	< 0.1%
-159.3390045	4	0.1%
-157.924228	6	0.2%
-157.095993	1	< 0.1%
-156.6730042	1	< 0.1%
-156.429993	10	0.4%
-156.045603	5	0.2%
-155.0480042	1	< 0.1%

Value	Count	Frequency (%)
-70.309303	12	0.4%
-70.82330322	1	< 0.1%
-71.00520325	3	0.1%
-71.420403	14	0.5%
-71.435699	10	0.4%
-71.8757019	3	0.1%
-72.68319702	1	< 0.1%
-72.88680267	1	< 0.1%
-73.10019684	2	0.1%
-73.15329742	1	< 0.1%

Destination_Latitude
Real number (ℝ)

Distinct	267
Distinct (%)	9.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	36.845718

Minimum	19.721399
Maximum	70.194702
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	43.6 KiB

Quantile statistics

Minimum	19.721399
5-th percentile	26.5362
Q1	32.733601
median	37.618999
Q3	40.788399
95-th percentile	45.588699
Maximum	70.194702
Range	50.473303
Interquartile range (IQR)	8.0547981

Descriptive statistics

Standard deviation	6.1957032
Coefficient of variation (CV)	0.1681526
Kurtosis	1.1029963
Mean	36.845718
Median Absolute Deviation (MAD)	4.1847
Skewness	0.17973533
Sum	102910.09
Variance	38.386738
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
41.9786	110	3.9%
40.78839874	80	2.9%
47.449001	76	2.7%
44.882	76	2.7%
33.43429947	72	2.6%
37.61899948	71	2.5%
39.87189865	68	2.4%
27.97550011	62	2.2%
28.77759933	54	1.9%
38.748697	54	1.9%
Other values (257)	2070	74.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
19.72139931	1	< 0.1%
19.738783	5	0.2%
20.8986	10	0.4%
20.96290016	1	< 0.1%
21.1529007	1	< 0.1%
21.32062	6	0.2%
21.97599983	4	0.1%
24.55610085	5	0.2%
25.79319954	36	1.3%
26.072599	23	0.8%

Value	Count	Frequency (%)
70.19470215	2	0.1%
66.88469696	1	< 0.1%
64.81510162	2	0.1%
64.5121994	2	0.1%
61.17440033	3	0.1%
60.77980042	1	< 0.1%
60.4917984	2	0.1%
58.35499954	2	0.1%
57.04710007	2	0.1%
56.80170059	1	< 0.1%

Auto

Heatmap
Table

	DEP_DELAY	ARR_DELAY	AIR_TIME	Flight_Num	DISTANCE	Passenger_Num	ITIN_FARE	Origin_Longitude	Origin_Latitude	Destination_Longitude	Destination_Latitude	Origin_TYPE	Destination_TYPE
DEP_DELAY	1.000	0.991	0.817	0.938	0.759	0.938	0.143	0.083	0.032	0.057	0.084	0.107	0.136
ARR_DELAY	0.991	1.000	0.804	0.933	0.743	0.933	0.160	0.082	0.042	0.059	0.098	0.100	0.126
AIR_TIME	0.817	0.804	1.000	0.855	0.987	0.854	0.243	0.048	-0.067	-0.083	-0.007	0.117	0.106
Flight_Num	0.938	0.933	0.855	1.000	0.792	1.000	0.157	0.050	-0.028	0.038	0.035	0.178	0.158
DISTANCE	0.759	0.743	0.987	0.792	1.000	0.791	0.234	0.041	-0.072	-0.103	-0.014	0.106	0.096
Passenger_Num	0.938	0.933	0.854	1.000	0.791	1.000	0.156	0.050	-0.028	0.039	0.035	0.177	0.157
ITIN_FARE	0.143	0.160	0.243	0.157	0.234	0.156	1.000	0.057	-0.018	-0.068	0.100	0.182	0.207
Origin_Longitude	0.083	0.082	0.048	0.050	0.041	0.050	0.057	1.000	0.129	0.483	-0.086	0.372	0.158
Origin_Latitude	0.032	0.042	-0.067	-0.028	-0.072	-0.028	-0.018	0.129	1.000	-0.006	0.077	0.358	0.160
Destination_Longitude	0.057	0.059	-0.083	0.038	-0.103	0.039	-0.068	0.483	-0.006	1.000	-0.079	0.147	0.310
Destination_Latitude	0.084	0.098	-0.007	0.035	-0.014	0.035	0.100	-0.086	0.077	-0.079	1.000	0.152	0.281
Origin_TYPE	0.107	0.100	0.117	0.178	0.106	0.177	0.182	0.372	0.358	0.147	0.152	1.000	0.059
Destination_TYPE	0.136	0.126	0.106	0.158	0.096	0.157	0.207	0.158	0.160	0.310	0.281	0.059	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	Route	ORIGIN	DESTINATION	ORIGIN_CITY_NAME	DEST_CITY_NAME	DEP_DELAY	ARR_DELAY	AIR_TIME	Flight_Num	DISTANCE	Passenger_Num	ITIN_FARE	Origin_TYPE	Origin_NAME	Origin_Longitude	Origin_Latitude	Destination_TYPE	Destination_NAME	Destination_Longitude	Destination_Latitude
0	ABE-ATL	ABE	ATL	Allentown/Bethlehem/Easton, PA	Atlanta, GA	3637.00	4933.00	43270.00	434	300328.00	56796.00	573.00	medium_airport	Lehigh Valley International Airport	-75.44	40.65	large_airport	Hartsfield Jackson Atlanta International Airport	-84.43	33.64
1	ABQ-ATL	ABQ	ATL	Albuquerque, NM	Atlanta, GA	1664.00	2016.00	54067.00	330	418770.00	43214.00	458.25	large_airport	Albuquerque International Sunport	-106.61	35.04	large_airport	Hartsfield Jackson Atlanta International Airport	-84.43	33.64
2	ABY-ATL	ABY	ATL	Albany, GA	Atlanta, GA	5036.00	4814.00	16953.00	498	72210.00	64616.00	462.75	medium_airport	Southwest Georgia Regional Airport	-84.19	31.54	large_airport	Hartsfield Jackson Atlanta International Airport	-84.43	33.64
3	AEX-ATL	AEX	ATL	Alexandria, LA	Atlanta, GA	5010.00	4730.00	49247.00	640	320000.00	82778.00	505.50	medium_airport	Alexandria International Airport	-92.55	31.33	large_airport	Hartsfield Jackson Atlanta International Airport	-84.43	33.64
4	AGS-ATL	AGS	ATL	Augusta, GA	Atlanta, GA	12268.00	12636.00	43867.00	1367	195481.00	176880.00	404.00	large_airport	Augusta Regional At Bush Field	-81.96	33.37	large_airport	Hartsfield Jackson Atlanta International Airport	-84.43	33.64
5	ALB-ATL	ALB	ATL	Albany, NY	Atlanta, GA	2800.00	2660.00	60980.00	500	426500.00	64904.00	513.25	medium_airport	Albany International Airport	-73.80	42.75	large_airport	Hartsfield Jackson Atlanta International Airport	-84.43	33.64
6	ASE-ATL	ASE	ATL	Aspen, CO	Atlanta, GA	2819.00	2669.00	30315.00	173	225592.00	22038.00	669.25	medium_airport	Aspen-Pitkin Co/Sardy Field	-106.87	39.22	large_airport	Hartsfield Jackson Atlanta International Airport	-84.43	33.64
7	ATL-CSG	CSG	ATL	Columbus, GA	Atlanta, GA	3412.00	3602.00	7185.00	277	22991.00	36652.00	474.00	medium_airport	Columbus Metropolitan Airport	-84.94	32.52	large_airport	Hartsfield Jackson Atlanta International Airport	-84.43	33.64
8	ABE-CLT	ABE	CLT	Allentown/Bethlehem/Easton, PA	Charlotte, NC	3588.00	4470.00	42947.00	502	241462.00	66374.00	440.00	medium_airport	Lehigh Valley International Airport	-75.44	40.65	large_airport	Charlotte Douglas International Airport	-80.94	35.21
9	AGS-CLT	AGS	CLT	Augusta, GA	Charlotte, NC	11626.00	11443.00	31339.00	966	135240.00	126368.00	358.50	large_airport	Augusta Regional At Bush Field	-81.96	33.37	large_airport	Charlotte Douglas International Airport	-80.94	35.21

	Route	ORIGIN	DESTINATION	ORIGIN_CITY_NAME	DEST_CITY_NAME	DEP_DELAY	ARR_DELAY	AIR_TIME	Flight_Num	DISTANCE	Passenger_Num	ITIN_FARE	Origin_TYPE	Origin_NAME	Origin_Longitude	Origin_Latitude	Destination_TYPE	Destination_NAME	Destination_Longitude	Destination_Latitude
2783	PSG-WRG	PSG	WRG	Petersburg, AK	Wrangell, AK	2298.00	2431.00	2225.00	173	5363.00	22446.00	340.25	medium_airport	Petersburg James A Johnson Airport	-132.95	56.80	medium_airport	Wrangell Airport	-132.37	56.48
2784	LAS-SMX	LAS	SMX	Las Vegas, NV	Santa Maria, CA	863.00	1020.00	4946.00	90	27900.00	12044.00	116.75	large_airport	McCarran International Airport	-115.15	36.08	medium_airport	Santa Maria Pub/Capt G Allan Hancock Field	-120.46	34.90
2785	LAX-RDD	LAX	RDD	Los Angeles, CA	Redding, CA	488.00	381.00	3725.00	49	24549.00	6012.00	266.00	large_airport	Los Angeles International Airport	-118.41	33.94	medium_airport	Redding Municipal Airport	-122.29	40.51
2786	MCO-PSM	MCO	PSM	Orlando, FL	Portsmouth, NH	268.00	308.00	12133.00	75	87525.00	10134.00	91.75	large_airport	Orlando International Airport	-81.31	28.43	medium_airport	Portsmouth International at Pease Airport	-70.82	43.08
2787	ORD-PAH	ORD	PAH	Chicago, IL	Paducah, KY	4579.00	4844.00	19290.00	299	102258.00	39474.00	321.25	large_airport	Chicago O'Hare International Airport	-87.90	41.98	medium_airport	Barkley Regional Airport	-88.77	37.06
2788	ORD-SLN	ORD	SLN	Chicago, IL	Salina, KS	4573.00	5184.00	12742.00	146	81614.00	18266.00	247.75	large_airport	Chicago O'Hare International Airport	-87.90	41.98	medium_airport	Salina Municipal Airport	-97.65	38.79
2789	ORD-UIN	ORD	UIN	Chicago, IL	Quincy, IL	5106.00	5314.00	11679.00	257	57054.00	32860.00	168.00	large_airport	Chicago O'Hare International Airport	-87.90	41.98	medium_airport	Quincy Regional Baldwin Field	-91.19	39.94
2790	MSP-RHI	MSP	RHI	Minneapolis, MN	Rhinelander, WI	5093.00	6720.00	13429.00	344	65360.00	44470.00	252.50	large_airport	Minneapolis-St Paul International/Wold-Chamberlain Airport	-93.22	44.88	medium_airport	Rhinelander Oneida County Airport	-89.47	45.63
2791	SEA-YKM	SEA	YKM	Seattle, WA	Yakima, WA	6456.00	7864.00	17512.00	610	62830.00	79180.00	232.00	large_airport	Seattle Tacoma International Airport	-122.31	47.45	medium_airport	Yakima Air Terminal McAllister Field	-120.54	46.57
2792	SLC-TWF	SLC	TWF	Salt Lake City, UT	Twin Falls, ID	4428.00	4641.00	19656.00	582	101850.00	77760.00	292.75	large_airport	Salt Lake City International Airport	-111.98	40.79	medium_airport	Joslin Field Magic Valley Regional Airport	-114.49	42.48

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Other Punctuation

Space Separator

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Other Punctuation

Space Separator

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category